SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date, ,>
-- Description:	<Description, ,>
-- =============================================
CREATE FUNCTION [dbo].[GetPosName]
(
	-- Add the parameters for the function here
	@PosId int
)
RETURNS nvarchar
AS
BEGIN
	-- Declare the return variable here
	DECLARE @pos nvarchar

	-- Add the T-SQL statements to compute the return value here
	SELECT @Pos = Position 
	From Position
	Where ID = @PosId;

	-- Return the result of the function
	RETURN @Pos

END
GO
